package com.financing.platform.dao;
import java.sql.SQLException;
import java.util.List;
import java.util.Map;

import com.financing.platform.dto.FpBiddingReceiptDTO;
import com.financing.platform.dto.FpBiddingRevenueDTO;
import com.financing.platform.vo.FpBiddingReceiptVO;


public interface IFpBiddingReceiptDao extends IBaseDao {
	/**
	 * 新增产品承销竞价
	 * @param dto
	 * @return
	 * @throws SQLException 
	 */
	public Integer addFpBiddingReceipt(FpBiddingReceiptDTO dto) throws SQLException;
	
	/**
	 * 新增产品承销返佣
	 * @param dto
	 * @return
	 * @throws SQLException 
	 */
	public Integer addFpBiddingRevenue(FpBiddingRevenueDTO dto) throws SQLException;
	/**
	 * 查询产品承销竞价
	 * @param dto
	 * @return
	 * @throws SQLException 
	 */
	public List<FpBiddingReceiptVO> queryFpBiddingReceipt(FpBiddingReceiptDTO dto) throws SQLException;
	
	/**
	 * 查询产品承销竞价count
	 * @param dto
	 * @return
	 * @throws SQLException 
	 */
	public int queryFpBiddingReceiptCount(FpBiddingReceiptDTO dto) throws SQLException;

	/**
	 *审核产品承销竞价
	 * @param dto
	 * @return
	 * @throws SQLException 
	 */
	public int updateBiddingReceipt(FpBiddingReceiptDTO dto) throws SQLException;
	
	
	/**
	 * 查询产品承销竞价Detail
	 * @param dto
	 * @return
	 * @throws SQLException 
	 */
	public Map<String,Object> queryFpBiddingReceiptDetail(FpBiddingReceiptDTO dto) throws SQLException;
	
	/**
	 * 查询产品承销成功的信息
	 * @param dto
	 * @return
	 * @throws SQLException 
	 */
	public Map<String,Object> queryBiddingReceiptSuccess(FpBiddingReceiptDTO dto) throws SQLException;
	
	/**
	 * 查询产品承销返佣的信息
	 * @param dto
	 * @return
	 * @throws SQLException 
	 */
	public List<Map<String,Object>> queryBiddingReceiptSuccessRebate(FpBiddingReceiptDTO dto) throws SQLException;
	
	/**
	 * 根据id查询   承销佣金
	 * @param dto
	 * @return
	 * @throws SQLException 
	 */
	public List<Map<String,Object>> queryFpBiddingRevenueList(int receiptId) throws SQLException;
	
	/**
	 * 查询需要解冻的保证金列表
	 * @param dto
	 * @return
	 * @throws SQLException 
	 */
	public List<Map<String,Object>> queryUnFreezingBailList(FpBiddingReceiptDTO dto) throws SQLException;
	
	
	/**查询竞价信息
	 * @param dto
	 * @return
	 * @throws SQLException
	 */
	public FpBiddingReceiptDTO queryBiddingReceipt(FpBiddingReceiptDTO dto) throws SQLException;
	
	
}
